<%@ page contentType='text/html; charset=iso-8859-1' language="java"%>
<%@ page pageEncoding="UTF-8"%>
<%@ include file="../WEB-INF/jspf/cabecalho.jspf" %>
<%@ include file="../WEB-INF/jspf/acesso.jspf" %>
<%@ include file="../WEB-INF/jspf/setMeta.jspf" %>

<sql:query var='rsetReg' dataSource='${con}'>    
    SELECT * FROM Usuario 
    WHERE Usuario.statusUsuario = 'Ativo'
    ORDER BY `nome` ASC 
</sql:query>


<form name="form1" method="post" action="">
  <fieldset>
  <legend><font color="#0000FF"><strong>Usu&aacute;rios do Sistema</strong></font></legend>
    <br/>
  <table width="20%" border="0">
     <tr bgcolor="#CCCCCC">
          <td width="10%"><div align="center"><strong>Ativos</strong></div></td>
          <td width="10%"><div align="center"><strong><a href="visualizarUsuariosDoSistema.jsp">Todos</a></strong></div></td>
      </tr>
    </table>
   <br/>
  <table width="100%" border="1" bordercolor="#0000FF">
    <tr bgcolor="#00CCFF"> 
      <td width="6%"><div align="center"><strong>C&oacute;digo</strong></div></td>
      <td width="40%"><div align="center"><strong>Nome</strong></div></td>
      <td width="24%"><div align="center"><strong>Perfil</strong></div></td>
      <td width="8%"><div align="center"><strong>Usuário</strong></div></td>
      <td width="6%"><div align="center"><strong>Equipe</strong></div></td>
      <td width="6%"><div align="center"><strong>Status</strong></div></td>
      <td width="10%" colspan="2"><div align="center"><strong>Manuten&ccedil;&atilde;o</strong></div></td>
    </tr>
    <c:forEach var="row" items="${rsetReg.rowsByIndex}">
        <tr> 
            <td><div align="center"><c:out value="${row[0]}"/></div></td>
            <td><div align="left"><c:out value="${row[1]}"/></div></td>
            <td><div align="left"><c:out value="${row[2]}"/></div></td>
            <td><div align="center"><c:out value="${row[3]}"/></div></td>
            <td><div align="center"><c:out value="${row[4]}"/></div></td>
            <td><div align="center"><c:out value="${row[7]}"/></div></td>
            <td><div align="center"><a href="editarDadosDeUsuarioDoSistema.jsp?chv1=<c:out value="${row[0]}"/>"><img src="imagens/icones/editar.gif" alt="Editar Dados do Usu&aacute;rio" width="16" height="16" border="0" /></a></div></td>
            <td><div align="center"><img src="imagens/icones/historico.gif" onclick="javascript:window.open('visualizarHistoricoDeUsuarioDoSistema.jsp?chv1=<c:out value="${row[1]}"/>','teste','height=500,width=650,scrollbars=yes,status=yes,left = 200,top=100')" style="cursor:hand" width="16" height="16" border="0" /></a></div></td>
        </tr>
    </c:forEach>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  </fieldset>
</form>

</body>
</html>
